Location: United States, Michigan
Location: United States, Colorado
Make your mark.Plante Moran's technology services team has been awarded Insider Pro and Computerworld's "100 Best Places to Work in IT" for five consecutive years. We are also previous recipients of the InformationWeek IT Excellence award and the CIO 100 award. If you're seeking professional growth, like being innovative and challenged, and have a desire to work on impactful business technology solutions, we want to hear from you!
What does diversity, equity, and inclusion mean to Plante Moran? It means that all staff members have equitable and fair opportunities to succeed, in an inclusive environment, with their individual, unique identities.
We are looking for a Data Engineer to be a senior member of the Data Services team which includes all data warehouse, data engineering and visualizations, database operations, and data science capabilities. This role will be a team member on our data engineering team supporting all data integrations activities at Plante Moran.
Your work will include, but not be limited to:
Develop new innovative Azure data technologies to design and develop innovative POC's and Project to address complex business issues.
Develop data solutions, POC to address current and future information system needs, and create process improvements and controls for defined solutions
Works closely with customers and colleagues to identify opportunities to utilize information systems to improve business processes, promote the strategic use of information while enabling seamless access to information.
Interacts with the staff to produce data mapping and requirements, deliver high quality solutions utilizing Microsoft Data Integration Stack
Provides prototyping solutions, prepares test scripts, and conducts tests and for data replication, extraction, loading, cleansing, and data modeling.
Possesses working knowledge of Relational Database Management Systems (DBMS) and data warehouse front-end tools.
Be proficient in creating and maintain SQL data structures and store procedures.
Works closely with the technical and business team lead to drive solution options analysis, development and implementation of BI solutions.
Contributing team member to the design and support of data architecture, database design and integration, transformations, and load processes.
Associate degree required
Bachelor's Degree preferred in computer science or related field preferred
Extensive Azure Data Technology design and implementation experience: ADF, Azure SQL, Azure Data Bricks, Azure Analysis Services, Data Lakes and Power BI
Informatica Experience (IICS) - Using Data integrator, Application Integration, Data Quality, Data Lineage
Experience creating data flows, executing stored procedures within SSIS
Experience setting up and troubleshooting SQL Agent Jobs
Azure Dev Ops and GitHub development management experience
SSMS and T-SQL Experience - Strong T-SQL Skills
3-5 years of experience using the Microsoft Azure Data integration tools including SSIS/IR, ADF, and ADO
Familiarity with database-centric applications
Proven experience with data warehousing and data modeling, specifically building/understanding Microsoft data storage structures
Proven ability to build out, enhance, and maintain the company data environment, including modifications and maintenance of various ETLs, transactional data sets, and company data assets.
Manage data access, data quality, and data delivery tasks within the framework of specific client BI and IT projects.
Ability to validate & ensure production level functionality/style is thoroughly tested, and the code reflects the current standards.
Problem Solver - Interested in finding solutions to/supporting existing solutions, as well as, continuing to advance through new development
Analytical approach to problem-solving; ability to use technology to solve business problems
Passionate about learning new technologies
Strong verbal and written communication skills; strong time-management and organizational skills
We are a nationally recognized public accounting, consulting, and wealth management firm, consistently ranked as one of FORTUNE magazine's "100 Best Companies to Work For." At Plante Moran, we live by the Golden Rule, fostering a relatively "jerk-free" culture with the lowest staff turnover rate in the industry. Our supportive network of well-rounded professionals is excited to catapult your growth and help pave your pathway to professional excellence.
Apply now. Make your mark.
This is an exempt position, so you may have to work hours that exceed the standard 40-hour work week.
Plante Moran is committed to a diverse workplace. We strive to create a culture where each person feels accepted and valued. We believe that each person's ultimate potential begins with first acknowledging their inherent dignity. When we can recognize - and celebrate - our many human differences, we're able to create a workplace where all staff feel a sense of belonging and an opportunity to succeed. This allows us to attract and retain the best talent, serve clients through diverse thinking, and better represent and support the various communities in which we live and work. Plante Moran is an Equal Opportunity Employer.
Plante Moran maintains a drug-free workplace.
Interested applicants must submit their resume for consideration using our applicant tracking system. Due to the high volume of applications received, only candidates selected for interviews will be contacted. Candidates must be legally authorized to work in the United States without sponsorship, with the exception of candidates that are bilingual in Japanese and English.... For full info follow application link.
Plante Moran is an Equal Opportunity Employer, committed to a diverse workplace.