Akkodis

Data Warehouse Developer Job at Akkodis in Rochester

Akkodis, Rochester, NY, US

Job Description

Akkodis is seeking a Data Warehouse Developer for a client in Rochester, NY. This is a hybrid role where the person will work onsite and remotely, so the person needs to live within 50 miles of Rochester, NY. No C2C or agencies for this role.

Rate Range: $50.00/hour to $54.00/hour; The rate may be negotiable based on experience, education, geographic location, and other factors.

TheData Warehouse Developerresponsibilities includedesigning and creating the data warehouse and all related extraction, transformation and load of data functions in the company. This means that theData Warehouse Developerneeds to be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process and Data Model around those goals.Candidates must have an advanced knowledge of relational databases, data querying constructs and strong data modeling skills. Database designs take on many forms, including Dimension models and Data Vault models.TheData Warehouse Developerwill work in a team with other Architects, ETL, BI and Database developers.

Responsibilities:

· Translate business requirements into technical code.

· Design and implement scalable and appropriately normalized models depending on the database layer of the data warehouse framework implements.

· Understand the various layers of the data warehouse and how data flows between them.

· Design and develop scalable and dynamic ETL code using SSIS/T-SQL and other modeling tools and technologies that requires little overhead with the passing of time.

· Develop stored procedures that reflect business rules and properly handling transaction committing failures.

· Identify and test for bugs and bottlenecks in the ETL code in order to deploy the most performant code.

· Mindful of data quality and timeliness of data availability in the data warehouse.

· Work with other Architects, ETL, BI and Database developers to deliver the business the requested data warehouse solutions.

· Worked on Azure data factory to create data transformations and data pipelines to transform the data from Flat file/blob storage to Azure SQL Database.

· Working with cloud computing technologies such as: Azure Data Factory, Azure DevOps, Hadoop, Microsoft Azure, and Databricks.

Required Skills and Experience:

· Proficiency with SQL Server, T-SQL and writing stored procedures.

· Proficiency with SSIS and the SSIS Catalog.

· Dimensional modeling experience.

· Data Vault modeling experience.

· Able to understand various layers of the data warehouse and how data flows between them.

· Experience designing and building complete ETL/SSIS processes moving and transforming data for Data Warehousing including Data Marts and Data Vaults.

· Proficient in how to deploy to and debug a production SSIS environment.

· Experience with versioning control tools like Git.

· Experience with agile methodologies and DevOps tools.

· Experience in identification of data quality.

· Experience in query optimization.

· Familiarity with scripting languages like PowerShell.

· Knowledge of C# is a plus.

· Experience with any Data Vault automation tool like Wherescape is a plus.

· Experience with Azure cloud services like ADF and logic app is a plus.

Required Education and/or Credentials:

· BE or BS degree in one of the following subject areas: Computer Science, Computer Engineering, Information Technology, or related field preferred.

· 3-5 years of experience as aData Warehouse Developerwith strong understanding of data warehousing architectures, theories, principles, and practices.

· 3-5 years of experience with SQL Server, T-SQL, SSIS

· Some scripting experience using C# and PowerShell preferred.

If you are interested in this Data Warehouse Developer job, then please click APPLY NOW. For other opportunities available at Akkodis go to www.akkodis.com. If you have questions about the position, please contact Jim Tobin at mailto:jim.tobin@akkodis.com">jim.tobin@akkodis.com

Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy" target="_blank">https://www.akkodis.com/en/privacy-policy.

Pay Details: $50.00 to $52.00 per hour

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.akkodis.com/en/us/candidate-privacy-policy

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

The California Fair Chance Act
Los Angeles City Fair Chance Ordinance
Los Angeles County Fair Chance Ordinance for Employers
San Francisco Fair Chance Ordinance

Company Description

Global Footprint, Local Impact: As part of the world's second-largest ER&D company, you'll join a network of 50,000 professionals across 30 countries, each contributing to impactful projects worldwide while benefiting from a close-knit community at a local level.

Diverse Career Paths: With services ranging from specialist recruitment to cloud infrastructure and sustainability, Akkodis offers a multitude of career paths. Whether you're a software developer, data analyst, or sustainability expert, there's a place for your skill set.

Commitment to Innovation: Innovation is our cornerstone. With continuous investments in analytics and market intelligence, we not only predict the future of technology – we create it. Your ideas and innovations will have the space to flourish.

Continuous Learning and Development: The Akkodis Academy offers unrivaled opportunities for learning and professional growth, ensuring you remain at the forefront of your field. Our culture values continuous improvement, both for our company and for your career.

Inclusive and Collaborative Culture: We believe in the power of diverse perspectives and collaborative work environments. At Akkodis, you'll find a community where inclusivity drives innovation and where every voice is heard.

Our Evolution and Your Role in It

Akkodis emerged from the strategic merger of AKKA Technologies and Modis in 2023, under the Adecco Group. This fusion created a powerhouse in digital engineering and technology, blending European engineering finesse with global technological capabilities. As we write our next chapter, your skills and vision will be instrumental in driving our continued success.

Empowering the Future

We're not just creating solutions; we're empowering industries to be more efficient, sustainable, and forward-thinking. Our work in industrial automation, product development, and custom software solutions is setting new standards in technology and engineering.

Join the Akkodis Community

At Akkodis, you're more than just an employee – you're a vital part of a community shaping the future. We're excited to see where your expertise can take us. Discover where you fit in our diverse range of opportunities and start engineering a smarter future with us today.

Company Description

Global Footprint, Local Impact: As part of the world's second-largest ER&D company, you'll join a network of 50,000 professionals across 30 countries, each contributing to impactful projects worldwide while benefiting from a close-knit community at a local level.\r\n\r\nDiverse Career Paths: With services ranging from specialist recruitment to cloud infrastructure and sustainability, Akkodis offers a multitude of career paths. Whether you're a software developer, data analyst, or sustainability expert, there's a place for your skill set.\r\n\r\nCommitment to Innovation: Innovation is our cornerstone. With continuous investments in analytics and market intelligence, we not only predict the future of technology – we create it. Your ideas and innovations will have the space to flourish.\r\n\r\nContinuous Learning and Development: The Akkodis Academy offers unrivaled opportunities for learning and professional growth, ensuring you remain at the forefront of your field. Our culture values continuous improvement, both for our company and for your career.\r\n\r\nInclusive and Collaborative Culture: We believe in the power of diverse perspectives and collaborative work environments. At Akkodis, you'll find a community where inclusivity drives innovation and where every voice is heard.\r\n\r\nOur Evolution and Your Role in It\r\n\r\nAkkodis emerged from the strategic merger of AKKA Technologies and Modis in 2023, under the Adecco Group. This fusion created a powerhouse in digital engineering and technology, blending European engineering finesse with global technological capabilities. As we write our next chapter, your skills and vision will be instrumental in driving our continued success.\r\n\r\nEmpowering the Future\r\n\r\nWe're not just creating solutions; we're empowering industries to be more efficient, sustainable, and forward-thinking. Our work in industrial automation, product development, and custom software solutions is setting new standards in technology and engineering.\r\n\r\nJoin the Akkodis Community\r\n\r\nAt Akkodis, you're more than just an employee – you're a vital part of a community shaping the future. We're excited to see where your expertise can take us. Discover where you fit in our diverse range of opportunities and start engineering a smarter future with us today.