Data Analyst/BI Engineer

2 weeks ago

Boston, United States Saxon Global Full time

Below is another new Data Analyst / BI Engineer role for the Office of the Comptroller. All I need in your submittals is answers to the following questions and a brief write up. They are hybrid 4 days per month. LMK if you have any question or resumes to look over. TY

In your response, please provide answers to the following questions:

How many years of direct experience does the candidate have in designing and developing data information systems? How many years of experience does the candidate have in designing and developing such systems within the Commonwealth's IT environment? Please list any relevant professional certifications the candidate has.

The BEST Program Data Analyst/BI Engineer (DA/BI) will work with a Team comprised of BEST Program staff, agency business and technical SMEs and the new solution system integrator (SI) and product vendor to design and implement the data information management and reporting strategies, tools, and outputs to provide a robust reporting and data analytics capacity for users of the new Financials solution. The implementation of the new Financials solution will provide users with the ability to run queries and reports on the live data in this application directly rather than waiting for data to be available through warehouse reports. Data will be integrated across modules permitting more robust, real-time reporting and analytics capabilities.

The BEST Program Data Analyst/BI Engineer will work with the BEST Financials Data Lead to identify reporting, dashboard and business analytics needs that will drive the configuration of standard reports and dashboards delivered through the new Financials solution. The DA/BI Lead will assist in leading requirements sessions with BEST staff, agency staff and the system integrator and product vendor to review the reporting and analytics capabilities of the new solution and to identify available configuration options. The DA/BI Lead will develop and maintain a list of selected configurations for each report and dashboard and work with reports/dashboard developers during configuration to assist in translating business requirements to the configured reports. The DA/BI Lead will also participate in testing configured reports and dashboards and in organizing user testing of these items.

Whenever feasible, the BEST Program intends to adopt delivered reports and dashboards, but in instances where reporting requirements cannot be met by the delivered solutions, the DA/BI Lead will work with business and the system integrator and product vendor to identify requirements for future report development and participate in testing of these items when they are developed. The DA/BI Lead will work with business and the system integrator and product vendor to identify opportunities for improving the availability of data for reporting and analytics by understanding the solution's capacities in this area, sharing that information with business and documenting implementation options with owners of other Commonwealth business intelligence and data analytics resources.

The DA/BI Lead will support data access for users in the following areas, working to improve data quality and access in the new solution:

Financials:
  • Acquire to Retire (Capital Asset Management)
  • Cash Management
  • Cost Allocation
  • Debt Management
  • Grants Financial Management
  • Operating Budget Management
  • Order to Cash (Revenue/Accounts Receivable)
  • Procure to Pay (Accounts Payable)
  • Program Management
  • Record to Report (Financial Reporting)
  • Reporting/Analytics
  • Sub-fund Management
  • Vendor Management and Self Service
Operations:
  • Maintenance and Warranty Management
  • Incident Management
  • Capacity Management
  • Availability Management
  • Performance Management
  • Security Management
  • Nightly Batch Jobs Management
  • Software Change Management and Testing
  • Disaster Recovery Testing and Management

Specific Duties
  • Contribute to the development of data reporting and data access through database queries, reports, and dashboards.
  • Gather information from agency business users and technical staff regarding the types of data, frequency of reports or dashboards, distribution of reports or dashboards, and other information as needed to understand the current reporting needs of agencies.
  • Participate in developing an approach to identifying reporting and data analytics needs across the new solution user community.
  • Document configuration decisions for each standard report and dashboard and provide guidance to report developers during the configuration stage.
  • Participate in testing of configured reports and dashboards and assist in coordinating user testing of these materials.
  • Support and manage enterprise architecture's data operations (optimize data processing, query performance and data quality) and data pipelines.
  • Integrate data from diverse sources using ETL processes and transform raw data into datasets used for analysis.
  • Implement robust security measures, monitor data access and develop access policies.
  • Provide technological expertise to capture, store and employ data catalogue and lineage to support governance initiatives.
  • Understand business requirements in the BI context and design data models to convert raw data to meaningful insights.
  • Perform SQL, DAX queries and functions in Power BI.
  • Receive training and hands on guidance from the system integrator and product vendor in how to build queries, reports, and dashboards in order to assist reports developers in their work.
  • Assist in the creation of job aids and other training materials to support report writing by agency users.
Required Skills
  • Experience in building complex queries, reports and dashboards using a range of web-based tools.
  • Knowledge of structured data, such as entities, classes, hierarchies, relationships, and metadata.
  • Proven ability to collaborate with business owners, information architects, content architects and other stakeholders to support common goals and approaches including:
  • Interviewing managers and other stakeholders to understand their data needs.
  • Interviewing users to understand what they need from data systems to boost their performance.
  • Translating business goals, user needs and process improvements into data management functions and requirements.
  • Explaining the capabilities of data systems to business managers and users as the new solution is designed and configured.
  • Providing guidance on project scoping to meet stakeholders' requirements.
  • Assessing whether data is fit for use by performing initial validation of data delivered as part of the project.
  • Exhibiting an excellent understanding of how data are used within business processes and its impact.
  • In-depth exposure to data quality concepts, best practices, and tools.
  • Experience in designing, developing and deploying business analytics dashboards using PowerBI.
  • Experience in Cloud Data warehouses like Snowflake, Redshift.
  • Familiarity with Snowflake Data sharing, Snowpipe and Snowpark.
  • Experience in ETL tools such as Pentaho/Informatica and proficient in SQL.
  • Well-developed system analysis skills.
  • Understanding and knowledge of IT standards and controls.
  • Proficient written and verbal communication and interpersonal skills.
Preferred Qualifications

Experience with Software as a Service cloud implementations particularly those in which legacy on premise applications have been migrated to cloud delivery options.

Minimum Entrance Requirements
  • Bachelor's degree in computer science, system analysis or a related study, or equivalent experience.
  • Minimum of 5 years of design and implementation experience in the areas of business intelligence/reporting and data warehousing.

CTR Hybrid Work Model

CTR began operating its hybrid work model on November 1, 2021. Under this policy, employees are currently required to work a minimum of four business days per month (two set by management and two set by the employee) on-site at CTR's Boston office and may work remotely the remainder of the time at a location approved by their supervisor, so long as they comply with the requirements of the telework policy. Under this policy, all employees must be able to report to the Boston office with little or no notice, even including the same workday should an exigent circumstance arise. Therefore, a reasonable proximity to the office is necessary. CTR does not reimburse for employees to travel to the office.

In addition, the successful candidate may be required to work primarily on site in Boston during the initial training and orientation period and/or for certain positions a primarily on-site role may be necessary.

  • Program Data Analyst/BI Engineer

    1 month ago

    Boston, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRequired Skills• In-depth exposure to data quality concepts, best practices, and tools. • Experience in designing, developing and deploying business analytics dashboards using PowerBI. • Experience in Cloud Data warehouses like Snowflake, Redshift. • Familiarity with Snowflake Data sharing, Snowpipe and Snowpark. •...

  • Azure Data Engineer/Data Engineer

    3 days ago

    Boston, United States VDart Inc Full time

    Job DescriptionJob DescriptionJob Title: Azure Data Engineer/Data EngineerLocation: Boston, MA-OnsiteDuration: 6+ MonthsSome of the key qualifications we are looking for:Have hands-on experience with writing Stored ProceduresHave experience working with Azure cloud platformHave experience working with ADF and ETL pipelinesUnderstand and worked with...

  • Azure Data Engineer/Cloud Data Engineer

    9 hours ago

    Boston, Massachusetts, United States VDart Inc Full time

    Job Title: Azure Data Engineer/Data EngineerJob Summary:We are seeking a highly skilled Azure Data Engineer to join our team at VDart Inc. As a key member of our cross-functional data engineering team, you will be responsible for designing, building, and maintaining large-scale data warehouses and data pipelines using Azure cloud platform.Key...

  • Data Engineer

    3 days ago

    Boston, United States Merican Inc Full time

    Job DescriptionJob DescriptionAzure Data Engineer [Insurance]Boston , MA - OnsiteLong TermJob Opportunity:As a Data Engineer, you will be part of a cross-functional, largely autonomous data engineering team. You should have excellent problem-solving skills, strong attention to detail, and the technical know-how to independently build solutions from start to...

  • Provider Data Analyst

    2 weeks ago

    Boston, United States Randstad USA Full time

    Direct Hire/ Permanent OpeningProvide Data Analyst / Healthcare Data AnalystLocation - Hybrid required at Assembly Row-Flexible hybrid schedule, 2-3 times a week. Tuesdays / another day depending on needSalary – 105-110 KCovid Vaccinations and Flu requiredHospital in Boston, MA is looking to add a Provider / MDM Analyst.Ideally this resource will have...

  • Provider Data Analyst

    1 week ago

    Boston, United States Randstad USA Full time

    Direct Hire/ Permanent OpeningProvide Data Analyst / Healthcare Data AnalystLocation - Hybrid required at Assembly Row-Flexible hybrid schedule, 2-3 times a week. Tuesdays / another day depending on needSalary – 105-110 KCovid Vaccinations and Flu requiredHospital in Boston, MA is looking to add a Provider / MDM Analyst.Ideally this resource will have...

  • Provider Data Analyst

    1 week ago

    boston, United States Randstad USA Full time

    Direct Hire/ Permanent OpeningProvide Data Analyst / Healthcare Data AnalystLocation - Hybrid required at Assembly Row-Flexible hybrid schedule, 2-3 times a week. Tuesdays / another day depending on needSalary – 105-110 KCovid Vaccinations and Flu requiredHospital in Boston, MA is looking to add a Provider / MDM Analyst.Ideally this resource will have...

  • Business Data Analyst

    1 month ago

    Boston, United States Shift Technology Full time

    Job DescriptionJob DescriptionThe future of insurance starts with AI. To date, Shift Technology's AI-powered products have benefitted more than 300 million policyholders globally by reducing underwriting risk, identifying more fraud, and automating critical tasks throughout the claims process. Shift harnesses the power of AI to enable the world's...

  • Data Engineer, Berxi

    3 months ago

    Boston, United States Berkshire Hathaway Specialty Insurance Full time

    Job DescriptionJob DescriptionWho are we? A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. As a part of Berkshire Hathaway’s insurance operations, we bring our...

  • Senior BI Architect

    4 weeks ago

    Boston, United States Kellton Full time

    Our client, a global financial services firm based in Boston, MA is looking to add a Senior BI Architect to their expanding team. Job Title: Senior BI ArchitectPosition Summary:Client is seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15)...

  • Senior BI Architect

    4 weeks ago

    Boston, United States Kellton Full time

    Our client, a global financial services firm based in Boston, MA is looking to add a Senior BI Architect to their expanding team. Job Title: Senior BI ArchitectPosition Summary:Client is seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15)...

  • Sr. Data Analyst

    1 month ago

    Boston, United States Manage My Dream, LLC Full time

    Job DescriptionJob DescriptionTitle: Sr. Data AnalystLocation: 1 Post Office Square, Boston-MADuration: 12+ monthsPosition Overview:The Data Analyst works as part of the Data Platform Team within the Data & Analytics Group. The primary responsibilities are to analyze enterprise and vendor datasets, understand data characteristics and methodologies, and...

  • Senior BI Architect

    4 weeks ago

    Boston, United States Kellton Tech Full time

    Job DescriptionJob DescriptionJob Title: Senior BI ArchitectPay rate = $75/hr on W2, $80/hr on C2CEx State employee preferred.Engagement Length: 15 monthsPosition Summary:Client is seeking a contract Senior BI Architect to design, develop, and implement our organization's BI strategy for a health data warehouse project for approximately fifteen (15)...

  • Data Analyst

    3 months ago

    Boston, United States knightsbridgesolutions Full time

    DescriptionWe are seeking a skilled and experienced Data Analyst to join our team. As a Data Analyst, you will be responsible for collecting, analyzing, and interpreting large datasets to uncover valuable insights that will drive business decisions. You will work closely with various stakeholders to understand their data needs and deliver accurate reports...

  • Senior BI Architect

    4 weeks ago

    Boston, United States Acro Service Corp Full time

    Job Title: BI Architect - Senior Duration: 10 Months (With possible extension)Hours Per Week: 40Location: : Boston, MA 02116 (Hybrid)Note: Must be local from MA or New England Area.Position Summary:Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months....

  • Senior BI Architect

    4 weeks ago

    Boston, United States Acro Service Corp Full time

    Job Title: BI Architect - Senior Duration: 10 Months (With possible extension)Hours Per Week: 40Location: : Boston, MA 02116 (Hybrid)Note: Must be local from MA or New England Area.Position Summary:Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months....

  • Senior Data Analyst

    2 months ago

    Boston, United States Stride Funding Full time

    About Us  Stride Funding is a venture-backed, mission-driven startup transforming access to education and career pathways. We are revolutionizing the way employers attract and retain critical talent, while simultaneously tackling the student debt crisis. (Yep, we think BIG.) Our innovative platform meaningfully connects employers, educational institutions,...

  • Senior Data Analyst

    2 months ago

    Boston, Massachusetts, United States Stride Funding Full time

    About Us Stride Funding is a venture-backed, mission-driven startup transforming access to education and career pathways. We are revolutionizing the way employers attract and retain critical talent, while simultaneously tackling the student debt crisis. (Yep, we think BIG.) Our innovative platform meaningfully connects employers, educational institutions,...

  • Senior Data Analyst

    3 months ago

    Boston, United States Grand Circle LLC Full time

    Job DescriptionJob DescriptionJob Title: Senior Data AnalystCompany: Grand Circle LLCLocation: Boston, MAJob Type: Full-time (Hybrid - 3 days in office)We are seeking a highly skilled and motivated Sr. Data Analyst to contribute to the development of cutting-edge solutions. If you are passionate about pushing the boundaries of technology and solving complex...

  • Data Engineer

    3 weeks ago

    Boston, United States Highview Staffing Full time

    One of Boston's most prestigious and successful Asset Management firms is looking to add an experienced Data Engineer to their team reporting in to the growing IT organization. The firm has been providing expert investment strategy and management for decades in the Boston market and across the globe. This is a full time permanent role that offers cutting...