POSITION: REPORTING ANALYST / ETL DEVELOPER
LOCATION: MARLBOROUGH, MA
TYPE: FULL TIME/DIRECT HIRE
Note: LOCAL CANDIDATES ONLY!
Our direct client is looking to hire a motivated, detailed oriented lead analyst & ETL developer. In this role, you will be supporting the reporting and analytics team with ETL solutions, advanced data analysis and support of the day to day operations of the team. Specific duties will require the applicant to have a strong background using the Microsoft Business Intelligence suite, with an emphasis on TSQL, SSIS and database architecture. The qualified candidate must have a minimum of 3 to 5 years of relevant experience.
Develop & Support ETL solutions
Assist Technical Lead with team operations
Provide project support, includes participating in meetings and project scoping
Adhoc analysis of travel data for internal review & external clients
Assist with customer support queries, such as data integrity and validation questions
Develop reports and dashboards with extensive graphical display of data
Analyze data and trends, and suggest performance improvement measures
Work effectively with the client management team to identify, estimate, prioritize, and resolve issues
Microsoft Business Intelligence tools, specifically SSIS and SSRS
Must have a good understanding of data relationships and a strong command of SQL syntax
Data warehousing, data mart and database technologies, standards, and methodologies
Database tuning and performance
Analysis and design skills, critical thinking, and analytical problem solving
Business Intelligence environment as an ETL Developer
High proficiency with Microsoft Excel
Not required but nice to have:
Experience with travel data
Experience with Talend or ETL similar tools
Database Administration and maintenance
Experience with 3rd party reporting tools
Exceptional service orientation.
Manage ongoing relationships with internal and external clients.
Strong written and verbal communication skills ; strong customer focus skills
Focused on achieving key objectives and goals relevant to success of the role.
Completes tasks in an organized and methodical manner to meet agreed objectives.
Able to multi-task and manage own time.
Persistence to get results.
Self-motivated and directed to achieve results.
Problem solving and analytical skills:
Proactively identifies problems and escalate without prompting.
Ability to analyze large volumes of information and break down into manageable portions in a logical manner.
Attention to Detail:
Able to focus on large volumes of data and identify errors or discrepancies.
Ability to relate with people and develop ongoing relationships that are mutually beneficial.
Recognizes the importance of teamwork to achieve objectives.
Ability to communicate and articulate ideas to both technical and non-technical people.
Can create documentation of systems and processes that are logical and easy to follow.