BI Technical Lead

Responsibilities:
* Business and Data Analyst capabilities with 10 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
* Reviews, analyzes, and evaluates business systems and user needs. Overseeind DR
* Provide support for database/dataset inventories.
* Analyze the logical and physical database models and ensure data models / data dictionaries are up to date.
* Generate and prepare meta data linking datasets to associated business processes. Senior role that has responsibility supporting the analysis and documentation of data asset inventories for existing software and systems.
* This role will be assisting with system transformation efforts ensuring that business processes are properly mapped to supporting system data assets.
* When data inventories are identified, this role will work with subject matter experts, SME's, from the business and technology teams to document links between the assets and business processes.
* Additionally this role may be asked to work with SME's to update data dictionaries and document important meta data associated with the assets that will streamline system transformation from existing mainframe based systems to a web based system.
* This role also loads datasets into relational databases creating table structures to link and cross-reference data assets with reports, applications, interfaces, batch processes and their associated business processes.
* Good oral and written communication skills are required.
* This position currently offers the option to work up to 100% remote, this could change to 100% in house. On-site at the Madison Yards Way, 4822 Madison Yards Way, Madison, Wisconsin.
Top Skills & Years of Experience:
* 10+ years of experience relational databases, and Structured Query Language (SQL).
* 10+ years of experience documenting and understanding complex business and data
* relationships, through Entity Relationship Diagrams (ERDs).
* Demonstrated communication experience, working with business and technical teams.
* 5+ years of experience developing and understanding ETL for data transformation.
* A well qualified candidate will additionally have experience with:
* Familiarity with Tableau.
* Familiarity with Business Objects.
* Tech Writing, with an emphasis on communicating between the business and technical
* needs of a cross functional project team.
* Experience using data modeling tools (ex: ERwin) and understanding Entity Relationship
* Diagrams, ERDs, and data modeling
* MS SQL Server
* Oracle

Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.

If you would like to complete our voluntary self-identification form, please or copy and paste the following link into an open window in your browser: ;/p>

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile:

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.

Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting .

We look forward to working with you.

Beacon Hill. Employing the Future

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.