Expert Technical Solutions is seeking a BI EDW Developer for one of our premier clients in Atlanta, GA. This person will develop code for extracting data from source systems and loading to the Enterprise Operation Data Store (ODS). Also, this person will create (ExtractTransformLoad) ETL for the purpose of loading to the Enterprise Data Warehouse. This role is expected to develop and support data visualizations and reports that have been developed using Power BI. The work will require understanding of Microsoft SQL Server based data warehousing. This is a 6 month Contract to Permanent position located in the Brookhaven area of Atlanta. This opportunity offers competitive pay and outstanding career growth. Responsibilities Implement, support and maintain data process models, including sourcing, loading, transformation and extraction. Implement business rules via stored procedures, middleware or other technologies. Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. Create SSIS Packages and SQL for transforming and loading data from source systems to the ODS and then to the EDW. Support and maintain ETL processes to accommodate changes in source systems and new business user requirements. Create Dashboards and Reports based on a set of User requirements, while adhering to Company and Industry standards. Define and capture metadata and rules associated with ETL processes. Education and Experience Bachelorrsquos Degree in Information Technology, Business Intelligence, Data Science, Management Information systems, or related field Equivalent work experience will be considered 4+ years using T-SQL or comparable SQL dialect such as PLSQL. 2+ years using SQL Server Integration Services for ETL data movement integration 2+ years using SQL Server Reporting Services Experience using SQL Server Management Studio and Visual Studio Data Tools Experience troubleshooting and monitoring SQL Agent job schedules. Experience working with Relational Data Warehouses where star-schema Kimball design practices have been adopted. Experience in PowerBi development (on premise or cloud) highly preferred Experience working in a Hybrid Cloud ndash On Premise
Associated topics: application, back end, c c++, c++, develop, devops, perl, php, python, software development engineer
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.