Work in Washington Veterans Jobs

Description:

Role and Responsibilities:

• Responsible for identifying opportunities for improving Business Intelligence Solutions at the enterprise level through the use of technology, exhibiting a broad knowledge base of multiple source systems and business units in a highly collaborative environment

• Works on complex projects/teams and acts as a mentor and lead to other Analysts

• This role acts as a liaison between business units and IT departments to translate business needs and objectives into Business Information solutions

• Collect, elicit, document business and functional requirements as per company standards

• Create user stories and write acceptance criteria

• Identify Data Sources, calculated measures, and other transformations (lookups)

• Establish processes and automation for the enterprise-grade Data & BI platform

• Participate in design and architecture of solution

• Develop source to target mapping documentation

• Establish and document application configurations from a business and technical perspective

• Deliver Business Requirements for the “consumption layer” (Datamart, Visualizations, etc.)

• Serve as a lead for Data Q&A – liaison between business, developers, and other technical teams

• Provide data and analytics support (i.e., SQL queries, Alteryx workflows, Tableau, PowerBI reports and dashboards)

• Identify, document and manage risks and issues

• Perform functional testing and data validation

• Develop and execute testing plans, scenarios and validate data accuracy

• Test data services (data pipelines, APIs) that feed downstream requirements (Dashboards, Models, etc.) to ensure that the data transferred correctly to the client application tools

• Liaison with Data Governance team regarding the data catalog

• Identify, update and integrate Data Cataloging and business glossary

• Lead and participate in user acceptance testing (UAT)

• Ensure Security, Governance, Enterprise Architecture guidance and protocols are adhered to

• Facilitate testing of Security models and Role-based Access Control instantiated for the various environments (to provide procedures and protocols)

• Transition application knowledge and project work to designated company resources

• Communicate progress, risks, and issues to the project team

• Work with team and vendors to execute project work, as needed  

Outcomes:

Following are some of the key deliverables expected from this role:

• Functional requirements documents (BRD) – with business requirements, dashboards and views, calculated measures, algorithmic inputs, SLAs, etc.

• “Source to Target” mapping documents

• Technical specifications documents (TSD) – with architecture, data dictionary definitions, data model specifications, wireframes, computations/formulae for calculated measures, etc.

• Test strategy, test plan and test cases for testing and data validation

• Create data testing/validation scripts/Alteryx workflows

• Produce operational support documentation (and runbooks with dev team’s help)

• Produce release notes/documentation

• Create documentation for change control.

• Provide end-user adoption support

• Other project documentation and artifacts as defined and assigned by Project Manager or Data & BI leadership

Building reports and conducting data analysis.

These analysts will get the data requirements from the business units. The Analysis is a key part.

We have a data modeling capability, but as a BI data engineer/analyst you must understand what data modeling is.

This is supporting multiple projects/programs.

Skills:

business analyst, requirements gathering, data modeling, data quality

Additional Skills & Qualifications:

Key Tools/Technologies:

• SQL and other relational database concepts and languages required

• Alteryx - data manipulation and massaging/preparation.

• Tableau - Dashboard/Reporting

• PowerBI - Dashboard/Reporting

• Python -

• SQL Server Management Studio

• Azure Synapse - we have our data lakes today, until we move to Snowflake it resides there.

• Advanced Excel, Word and PowerPoint

• Data Modeling tools such as ErWin, Embarcadero, etc.

• Data quality, governance and cataloging tools such as Purview, Collibra, Ataccama, Alation, etc.

• Data ingestion/ETL tools such as Informatica, SSIS, Matillion, Talend, etc.

• Data warehouses, Data Lakes, and other data products such as Snowflake, Databricks, etc.

• Finance/Fintech applications, systems, processes and best practices

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.