We are hiring an ETL developer / data modeler for a multi year federal program in Bethesda, MD that will have expertise in designing and developing automated processes to extract, transform, and load data and metadata so they can be loaded into the data warehouse using a mixture of MS SQL Server Integration Services, Python, ArcGIS, SAS, and SQL scripts. The candidate will help the team review and analyze the current database and ETL design, recommend improvements based on business needs, performance improvement, and industry best practices. The candidate may also help the team implement approved changes to the system. Coordinates with the team to complete activities proper documentation of the database design, ETL design, data models, and recommendations. Will work with the business and IT delivery teams to identify and mitigate risks to include business operational risks. Escalates issues and develops and recommends appropriate solutions.
Seven or more years of SQL Server development experience with at least five years Integration service experience.
Demonstrated experience with SQL Server Integration Service to accomplish regular, non-disruptive data refreshes implementing data validation, business rules, and aggregations; design error handling and deployment plans.
Experience building data refreshes in SQL Server Integration Service from ground up without using any existing packages.
Intermediate to advanced relational and dimensional data modeling, database design, and technical design skills.
Intermediate to advanced SQL data integration skills.
Understanding of source and target data structures.
Understanding of data analysis and presentation concepts that facilitate collaborative work with BI Analysts and end users.
Ability to read technical documentation and architecture artifacts.
Familiar with Agile processes.
Understanding of system analysis, business analysis, and requirements development and able to utilize such information in analyzing and solving complex problems.
Ability to work quickly and efficiently in designing and implementing technical solutions.
Ability to analyze technical and functional aspects of a program and troubleshoot complex issues, take corrective actions and implement improvements.
Ability to work successfully in a team environment and possess the flexibility and adaptability to changing requirements is required.
Ability to translate needs analysis results into functional designs and to develop and learn new technical skills quickly.
Familiarity with process recovery capabilities, outcome monitoring and audit recording is preferred.
Exposure to GIS data, data management with ArcGIS, and Python geoprocessing scripting a plus
Design conceptual and logical models for data warehouses.
Update data models to meet new and changing business requirements.
Map source system data to data warehouse models.
Develop, test, and maintain ETL processes for all sources and destinations in SQL Server SSIS.
Adapt ETL processes to accommodate changes in source systems and to respond to changes in business requirements.
Develop processes for capturing and maintaining metadata from all data warehousing components
Define and capture metadata and rules associated with ETL processes.
Maintain recommended specifications for client access, application servers, database servers and networks
Work collaboratively with Product Owners and Subject Matter Experts to identify and understand source data systems.
Provide a feedback loop to advise on data standards in transaction systems that will lend better to long term analytic use of institutional data.
Produce technical documentation such as designs, process flow diagrams, data flow diagrams, decision trees, and data dictionaries
Bachelor’s degree (or 10 years of work experience)
Expert knowledge of MS SQL server
Expert knowledge of ETL and SSIS
5 years experience leading project teams and collaborating with customer stakeholders.
Working knowledge with Agile Scrum and Kanban technical software delivery methodologies
Working knowledge of Microsoft Office products and applicable databases
Masters degree with a concentration in computer science or related discipline
6+ years of relevant experience in database architecture and database engineering
Relevant work experience with Agile
Experience with EPLC development lifecycle
Recent experience designing/redesigning large databases and ETL packages
Experience with Erwin data modeling
Experience in healthcare industry.
Clearance: Ability to Obtain a Public Trust
US Citizenship or Authorization to work in US required
Travel: < 10% (CONUS)
Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V
No third parties or subcontractors
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if: