Senior Data Warehouse & BI Developer

Padmore Global Connections LLC; Atlanta (GA); On-site; USD 55,000 - 96,000; Full time

Job summary

Padmore Global Connections LLC is seeking a data warehousing and BI specialist to oversee data integration, modelling, and governance across on-premise and cloud platforms. You will translate business requirements into data pipelines, collaborate with architects, and optimize ETL processes while ensuring data quality and security for stakeholders.

Requirements include 5+ years in data warehousing/BI, expertise in MS SQL Server, SSIS, T-SQL, Power BI, and Azure data services.

Qualifications

• 5+ years in Data Warehousing and BI.
• 3+ years in BI with Microsoft SQL Server; expert in T-SQL.
• 5+ years in SSIS and use of Stored Procedures.
• 2+ years in Power BI.
• Ingest and aggregate data from internal/external sources for the data warehouse.
• Strong data modeling across conceptual, logical, and physical models.
• Relational database design concepts and SQL programming.
• Experience mentoring developers.
• Analytical, conceptual and problem-solving abilities.
• BI and data warehousing best practices.

Responsibilities

• Collaborate with stakeholders to translate business requirements into data integration routines.
• Identify data sources, provide data flow diagrams, and document source-to-target mappings.
• Collaborate with the Data Architect to recommend optimal data models and BI reporting structures.
• Provide technical enablement to team members developing database applications on prem or in cloud.
• Design, implement and maintain database objects (tables, views, indexes) and security.
• Collaborate with data stewards to enforce data quality, validation, and documentation.
• Maintain data warehouse performance through batch processing optimization and tuning.
• Establish processes for metadata governance and data quality in BI environments.
• Coordinate deployments and releases; support after-hours on-call as needed.
• Experience with GitHub and CI/CD pipelines.

Skills

Data Warehousing

Business Intelligence

T-SQL

SSIS

Power BI

Stored Procedures

GitHub

CI/CD

Analytical skills

Relational DB design

Data Modeling

Mentoring

Azure Data Factory

Azure Synapse

Education

Bachelor's degree in computer/information sciences or business/commerce

Tools

GitHub

CI/CD pipelines

Azure Synapse

Azure Data Factory

Job description

Padmore Global Connections LLC is seeking a data warehousing and BI specialist to oversee data integration, modelling, and governance across on-premise and cloud platforms. You will translate business requirements into data pipelines, collaborate with architects, and optimize ETL processes while ensuring data quality and security for stakeholders.

Requirements include 5+ years in data warehousing/BI, expertise in MS SQL Server, SSIS, T-SQL, Power BI, and Azure data services.