Microsoft Data Integration Engineer

IT Data Solutions
South florida, FL
26 Jan 2025

Vacancy expired!

Title: Microsoft Data Integration Engineer

Location: Miami, FL

Duration: 6+ Month Contract

Client: State Government Agency

Rate: Depends on Experience

Task Order: (TO-DE-U21)

Must be able to pass a full background check

Scope of ServicesThis professional position reports to an assigned supervisor and may exercise some degree of autonomy in accomplishing the IT department's strategic goals while providing technical support and project execution for various departments. This includes assisting other technical staff and stakeholders with the planning, development, installation, configuration, maintenance, support, and optimization of all business intelligence systems as required. The person will also assist technical staff as required to analyze and resolve end user computing experience and global customer issues in a timely and accurate fashion. In addition, this position will provide end user and peer training where required.

Education
  • Bachelor’s Degree in the major field of computer science, information systems, or any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed.

Experience Required
  • The ideal candidate has practical experience with data integration projects, data warehouse implementations, and master data management practices.
  • The candidate must be an expert in ETL and/or reporting processes.
  • Translate business requirements into specifications that will be used to implement the required reports and dashboards.
  • Work with business units to gather requirements, development, and delivery of business intelligence & reporting services.
  • Working with a variety of data formats, primarily - flat files (CSV, XLS), and XML/ SOAP / JSON / JMS.
  • Creating SQL Queries to extract the requested data from a variety of source databases.
  • Performance tuning Stored Procedures for maximum efficacy.
  • Creating a reusable / repeatable process in SQL Server Integration Services (SSIS)
  • Deploying and executing SSIS Packages
  • Running SSIS Packages in SQL Server Data Tools (SSDT) to debug and test packages to ensure they are in the correct format requested
  • Develops and implements business intelligence & analytics to support organizational initiatives.
  • Design, model, develop & optimize BI solutions to meet data management and data reporting objectives.
  • Troubleshoot and resolve issues with the processes used and the content produced by the BI platform.
  • Work with business stakeholders to define and improve standardized and ad-hoc analytics/reporting capabilities.
  • Work as part of the BI team to maintain and develop all components of the BI platform.
  • Provide ongoing maintenance support through troubleshooting, report modifications and optimization.
  • Provide input into the technical architecture and the data warehouse technology stack.
  • Create functional and technical design documents and maintain documentation for all reports and dashboards created or modified.
  • Creates and maintains positive, cohesive work environment.

Job Specific Knowledge, Skills, and Abilities (KSAs)The knowledge, skills, and abilities desired for this position include, but are not limited to the following:
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Excellent verbal and written communication skills.
  • Excellent project management skills including the ability to prepare prioritize and complete work plans.
  • Decision-making and problem-solving skills including the ability to clearly define and resolve issues.
  • 4+ years production SQL Server and Business Intelligence development and support
  • 3+ years Production experience working with Microsoft SQL Server (SSRS),(SSIS),(SSAS),(Power BI), API, C#, VB.NET
  • Experience with data integration methodologies and tools
  • Experience with the design of relational and multidimensional database
  • Strong proficiency in SQL performance tuning
  • Understanding of SDLC lifecycle
  • Knowledge of Source Control practices
  • Azure Data Platform (Azure Data Factory, Data Lakes, Azure Synapse Analytics, Azure ML, Databricks, Azure Cosmos DB, Power BI)

About IT Data:

Since 2005, IT Data Solutions has been providing focused management consulting services specializing in Information Technology (IT) solutions and tools for large private and public sector clients. We specialize in Advisory, Analytics, Audio/Video Design and Implementation, Augmented/Virtual Reality, Cybersecurity, Human Capital Solutions, Managed Services, and Robotic Process Automation (RPA). We turn big data into actionable intelligence to help reach your mission objectives. Our IT data solutions help you to increase efficiencies, reduce costs, and streamline processes.We are an Equal Opportunity Employer.
  • ID: #48833449
  • State: Florida South florida 33101 South florida USA
  • City: South florida
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-01-26
  • Deadline: 2023-03-25
  • Category: Et cetera