Overview TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. We are a community of 50 million who think—and feel—differently about investing. Together, we’re changing the way the world invests. Since our founding in 1975, helping investors achieve their goals has been our main reason for existence. At Client, we’re built differently. Our client is investor-owned, meaning that we’re owned by our funds, which are owned by our fund shareholder clients. Therefore, your success adds to ours, so you’re surrounded by people who care about the same things. With no other parties to answer to, we make decisions—including keeping investing costs as low as possible—with your needs in mind. Because of our unique structure, your goals align with our goals. Position:  Business Intelligence Engineer III (Data Integrity Manager) Location: Seattle, WA 98101 Duration: 8 Months Job Type: Contract Work Type:  Onsite Job Description Key Responsibilities: • Perform data management tasks, ensuring accuracy, consistency, and integrity of data across various systems and platforms • Conduct routine data quality checks, identify and resolve data discrepancies, anomalies, and out-of-range values • Implement and maintain data governance policies and procedures, collaborating with team members to document data processes and maintain data lineage • Provide support in the creation of data reports, dashboards, and visualizations, ensuring alignment with data visualization best practices • Participate in data audits and assist in the preparation of data-related documentation • Communicate with stakeholders to understand data requirements and provide updates on data quality improvements • Maintain a strong understanding of data security, privacy, and compliance requirements • Leverage Python scripting and SQL querying skills to automate data cleansing and correction processes • Trace and isolate sources of data issues, including cell links, automations, scripts, and other dependencies • Work with the central data analytics team to identify and implement necessary modifications to data pipelines and configurations • Assess when to apply manual intervention versus automation for efficient data correction and enhancement • Perform other ad-hoc data-related tasks as assigned by the team lead or manager Basic Qualifications • Bachelor's degree or equivalent • 3+ years of experience in a data management or data analytics related role • Proficient in using spreadsheet software (e.g., Microsoft Excel, Smartsheet) and writing advanced functions, automations, and data meshes • Experience with relational databases and SQL querying, including the use of window functions and complex joins • 3+ years of experience with data visualization platforms, including creating calculated measures and working with denormalized data (preferred: Quicksight) Preferred Qualifications • Python scripting experience, including libraries such as Pandas (preferred: experience with API calls and the Smartsheet SDK) • Understanding of AWS data services such as AWS Glue, Redshift, or AWS Lambda for data processing and ETL • Ability to independently troubleshoot and logically infer causes of data issues by isolating variables and testing • Experience using IDEs such as DataGrip, VSCode • Knowledge of effective data visualization design principles Typical Day In The Role Day to Day: • Data Reporting and Visualization (40% of time) • Create data reports, dashboards, and visualizations based on stakeholder/Team/Project requirements using tools like Quicksight, Tableau, Smartsheet, Excel Sheet. • Ensure alignment of data visualizations with the project and teams goal. • Provide support and guidance to stakeholders/cross functional teams on interpreting data insights/queries. • Data Automation and Scripting (20% of time) • Leverage Python scripting and SQL querying skills to automate data cleansing and correction processes • Develop scripts and workflows to improve data processing efficiency • Assess opportunities to apply automation versus manual intervention • Data Governance and Documentation (15% of time) • Maintain and update data governance policies and procedures • Document data processes and data lineage • Collaborate with team members to ensure consistent data management practices • Data Quality Assurance (15% of time) • Conduct routine data quality checks across various systems and platforms like Salesforce, Cloud Forge, REV and internal Project Management tools like ( SIM, Smartsheet) • Identify and resolve data discrepancies, anomalies, and out-of-range values • Implement data validation rules and data cleansing processes to handle the data integrity, data availability issues. • Stakeholder Collaboration and Troubleshooting (10% of time) • Communicate with stakeholders to understand data requirements and provide updates • Troubleshoot and isolate sources of data issues, including dependencies • Participate in data audits and assist in the preparation of data-related documentation • Candidate Requirements: Leadership Principle • Customer obsession • Invent and simplify • Learn and be curious • Dive deep • Insist on higher standards Yoe • 3+ years of experience in a data management or data analytics related role • Proficient in using spreadsheet software (e.g., Microsoft Excel, Smartsheet) and writing advanced functions, automations, and data meshes • Experience with relational databases and SQL querying, including the use of window functions and complex joins • 3+ years of experience with data visualization platforms, including creating calculated measures and working with denormalized data (preferred: Quicksight) Degree/certs • Bachelor's degree or equivalent Resume Stand Out • Advanced Data Visualization and Dashboard Design • Cloud-based BI Platform Expertise (Quicksight, S3, Redshift, AWS Glue, AWS Lambda, CloudWatch) • Expertise in ETL Process and Data Management and Analysis • Previous experience as an client Top 3 Must-have Hard Skills • Proficiency in using spreadsheet software (e.g., Microsoft Excel, Smartsheet) and writing advanced functions (e.g., Pivot, Index), automations, and data meshes • Experience with data visualization platforms, including creating calculated measures and working with denormalized data (preferred: Quicksight, Tableau) • Strong experience with relational databases and SQL querying, including the use of window functions and complex joins TekWissen® Group is an equal opportunity employer supporting workforce diversity.