BI Architect II (UI/UX design)

Full Time United States - Missouri - Maryland Heights Posted 02/08/2021 Areas of interest: Business Intelligence Requisition Number: 274911BR BBL602

Responsible for building and designing innovative and company-leading visualizations for reports and dashboards. Operates within the Business Intelligence group to evaluate the stories business stakeholders need to tell with data, and offers recommended designs on how best to convey that story through visualizing data. Role will additionally define best practices and standards for report visualizations, to ensure readability, consistency, and a positive overall user experience. Will operate across web, mobile, and embedded visualizations primarily via MicroStrategy and supported visualization modules. Responsible for evaluating new visualization features available publically or from vendors, as well as performing architectural reviews of new reports being promoted to production. Actively evaluates MicroStrategy platform for performance tuning opportunities, and assists report developers to design and engaging report workflows and data visualization products.

Partner with Business Intelligence leaders to identify visualization opportunities and provide internal consultation and recommendations on how best to present data to users. Advocate for the use of visualizations to convey a message, and support the continued transformation of Charter into a data and analytics-driven organization.

Performs a number of roles within the BI Architecture group:
•Define and document standards for report format, visualizations, and user-experience function. Standards to apply across web, mobile, embedded, and emailed reports
•Consults with teams supporting the business teams to identify best reporting & visualization tools to meet requirements
•Review and approve new reports, dashboards, and visualizations before they are promoted to production, to ensure they are performant, usable, and meet standards
•Helps to troubleshoot and provide support for broken report visualizations, non-performant reports, and other issues around the configuration/setup of the BI tooling
•Evaluate and test new features/releases of MicroStrategy and provide recommendations and approach for better adoption
•Use dimensional modelling for better architecture, recommendations and add to existing standards
•Constantly tune the cubes and reports to meet SLA, and test/support the growth of cubes
•Use MicroStrategy Enterprise Manager and Platform Analytics data to drive some key performance and architecture initiatives
•Work with BI verticals to design the reporting framework and provide assistance with guided workflows and logical workflow on both web & mobile reporting

Evaluate and manipulate data as required to test, model, or trial the use of reports and visualizations
Monitor technology, vendor, and industry trends for new data visualizations, and participate in strategic projects that intend to introduce or utilize new methods of displaying data and associated analytics
Collaborate with analysts and report developers during the design and development stages to strategize approaches to build new reports and associated visualizations
Collaborate with team members working to improve the user experience of legacy/existing reports, provide expert guidance on conveying data through visualizations and usability/readability advice
Develop new reports as required, and build demo-reports to showcase visualization possibilities with the aim of inspiring their appropriate use
Perform other duties as requested

Qualifications/Experience (TBD, with language required for the selected job title):
•Deep familiarity with MicroStrategy highly preferred
•Tableau experience
•Ability to design and manipulate visualizations using D3.js library and associated technologies
•Prior experience creating complex report visualizations, such as Sankey, Journey, or Infographics
•Supplied portfolio of visualizations preferred

Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)
Experience in logical and physical database design for data warehousing (3NF/Star Schemas) including SQL writing/tuning on MPP platforms such as Teradata and/or Netezza
Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints
Strong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomes
Experience in developing roadmaps for BI Architecture discipline
Experience in developing and implementing complex data warehouse and BI solutions

Certification on Teradata and/or MicroStrategy is a plus
Familiarity with predictive modeling tools like SAS and/or R
Familiarity with Big Data technologies such as Hadoop and Spark is a plus but not required
Experience in cable or another telecommunications service provider is a plus
Familiarity with Agile development methodologies such as Scrum, Kanban and SAFe
Familiarity with cloud EDW solutions like Snowflake or Redshift a plus.
Prior experience deploying and managing cloud IaaS a plus.

Bachelor’s degree or foreign equivalent in Economics, Mathematics, Computer Science; or equivalent training, education and experience
Master’s degree preferred

Related Work Experience
Architect in large-scale, complex BI/DW environments, with
numerous data sources, 8+
Erwin Data Modeler, ER/Studio or similar data modeling tools, 3+
ELT/SQL Development on Teradata or similar MPP database platform, 2+
ETL platforms such as Informatica, Ab-initio or Data Stage, 2+
BI reporting/OLAP platforms such as MicroStrategy (preferred), Cognos, Business Objects, 2+

Office environment
Travel - 10%.

The health and safety of our employees and candidates is very important to us. Spectrum has adopted virtual mobile recruiting tools that allow us to continue meeting new candidates. We look forward to “virtually” meeting you.

The Spectrum brands (including Spectrum Networks, Spectrum Enterprise and Spectrum Reach) are powered and innovated by Charter Communications. Charter Communications reaffirms its commitment to providing equal opportunities for employment and advancement to qualified employees and applicants. Individuals will be considered for positions for which they meet the minimum qualifications and are able to perform without regard to race, color, gender, age, religion, disability, national origin, veteran status, sexual orientation, gender identity, or any other basis protected by federal, state or local laws.

Related jobs

View All of Our Available Opportunities

Sign up for job alerts

Sign up to receive the latest career opportunities directly to your inbox.

Areas of interestEnter a location and a category, and click "Add" to create your Job Alert.

  • Business Intelligence, Maryland Heights, Missouri, United StatesRemove

Spectrum employeeAre you currently a Spectrum employee?