What are the responsibilities and job description for the Business Intelligence Data Modeler position at firstPRO, Inc?
firstPRO is now accepting resumes for a BI Data Modeler in Boston, MA. This is a direct hire role and onsite 2-3 days per week.
ESSENTIAL JOB DUTIES
- Develop plan for business intelligence initiatives, recommend innovative technologies, methods, and industry-leading data modeling tools and best practices, design and maintenance of a system to warehouse data and information, including structured and unstructured data sets. Organize and transform data into comprehensible data models.
- Map data from new sources to the central data model to support the creation of new or extension of existing reports/dashboards and perform data validation. Provide requirements and execute data extraction, transformation, and load procedures.
- Support Argos and Tableau platforms through building data pipelines to facilitate the growth of dashboards and incorporate new and diversified data sources.
- Manages all technical aspects of our business intelligence environment, including data transformation and governance, performance monitoring and identification and support of analytics tools. Conduct regular architecture, security, data management, permissions reviews to enable proper data access/management to sources.
- Use complex data analysis and query, data science and data modeling techniques to develop reports and data analytics solutions. This includes engineering solutions in the form of business dashboards, reports and data visualizations integrating with internal and external public data sources like College Board or IPEDS. Provide statistical analysis of data, predict trends on business and academic performance, use data mining to extract information from data sets and identify correlations and patterns.
QUALIFICATIONS
- Bachelor’s Degree in Computer Science, Management Information Systems, Business or a similar degree, combined work experience and education as equivalent
- 10 years’ combined experience as data modeler, business intelligence analyst or advanced report writer
- 6 years’ experience in database systems management. Hands on experience in data model/data warehouse design. Solid understanding of dimension/fact table structure and data aggregation.
- 5 years of experience in ETL tools and procedures
- Programming language(s) for ETL and data pipelining
