Data Engineer/Reporting Analyst

About Accenture Federal Services

At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the limitless potential of technology and ingenuity for clients across defense, national security, public safety, civilian, and military health organizations.

Join Accenture Federal Services, a technology company within global Accenture. Recognized as a Glassdoor Top 100 Best Place to Work, we offer a collaborative and caring community where you feel like you belong and are empowered to grow, learn and thrive through hands-on experience, certifications, industry training and more.

Join us to drive positive, lasting change that moves missions and the government forward!

The Work: Data Engineer/Reporting Analyst

Seeking a motivated, experienced Data Engineer with strong technical, logic and interpersonal skills who is up for the challenge of joining a high-performing Data Engineering/Analytics team. As a Data Engineer/Reporting Analyst, you will work with our team of senior data engineers to develop and deploy complex data development solutions to meet the expanding needs of our client and business associates. We foster a supportive, collaborative, and fun environment where team members are empowered to push the envelope of learning and creativity.

As a Data Engineer/Reporting Analyst you will work directly with senior data engineers to create complex technical solutions while liaising with developers, applications/operational staff, technical project managers, test engineers and cloud engineers. You will creatively explore the boundaries of SQL Server capabilities to prototype, design and deliver optimal, and maintainable code while assisting with database design and production deployment and support activities.

Key Responsibilities

• Develop back-end code in a Microsoft SQL server environment
• Develop solutions to move data between SQL Server and Microsoft Dynamics 365
• Develop solutions using Azure Data Factory, SSIS, SQL Server, stored procedures and APIs
• Use Requirements gathering, research to develop insightful conclusions and generate solutions to address user needs
• Assist in documentation of current processes and development of documentation for new processes along with other methods of knowledge sharing.
• Ensuring data accuracy, performance, usability, and functionality requirements of the ETL platform
• Participate in the full software development life cycle, including solution design, development, code review, source code control, testing, deployment
• Prioritize attention to detail and accountability to meet critical deadlines. Flexibility in schedule based on business need. While night and weekend work is generally not required, critical deliverables must go out on time

Here is what you need

• Bachelor’s Degree or relevant experience in lieu of degree.
• 5 years of relevant experience.
• Experience analyzing data and presenting information to stakeholders.
• Experience with programming or SQL or BI Platform.
• Must be a US Person

Preferred experience

• Active Public Trust clearance
• Experience using Azure
• Experience using Azure Data Factory
• Experience with ETL/ELT
• Advanced SQL skills
• Experience with advanced Microsoft SQL Server programming of functions, triggers, and stored procedures
• Knowledge of SSIS, stored procedures and APIs
• Experience with GitHub
• Knowledge of Azure DevOps
• Knowledge of relational and dimensional data modeling
• Ability to communicate clearly both verbally and in communications and documentation

Key skills/competency

• Data Engineering
• SQL Server
• Azure Data Factory
• ETL/ELT
• Data Analysis
• Reporting
• SSIS
• APIs
• Data Modeling
• Software Development Life Cycle