Data Modeling Specialist job description template

I have 10 years of professional experience in data integration. I have extensive experience in all Informatica tools (Powercenter, MDM, IICS, Data Catalog, Analyst, Developer). I have strong hands on experience in various data sources including; Flat Files, MQ, Oracle, Netezza, DB2, SQL Server, Microsoft Access, and Teradata. I also have extensive experience and exposure to the various areas of SDLC and Agile methodologies. I’ve gathered requirements, submitted data models, developed, tested, debugged, deployed, documented, and provided production support. I have expertise in a number of reporting tools also such as Microsoft Excel, Tableau, PowerBI, Cognos, and Business Object. I’ve performed upgrades across these reporting tools as well.

I am an experienced research and People assessment specialist with experience developing and analyzing surveys [have experience evaluating psychometrics (validity and reliability) of results from surveys and tests]. Extensive knowledge and experience implementing statistical models, psychological theories, and business theories that improve efficiency within organizational operations. Developed statistical algorithms based on need assessments that improved selection measures, improved cost effective strategies to maximize profit, and optimized talent acquisition methodologies. Experience with software including SPSS, SAS, and R. Core skills include, statistical analysis, SQL, Excel, Statistical Programming (R, PYTHON), Data Visualization, Machine Learning, job analysis, need assessments, survey development, performance evaluation, management, statistical analysis, measure development, measure validation, factor analysis, compensation model implementation, employee training, employee selection, effectiveness analysis, change impact analysis, diversity and inclusion analysis, adverse impact analysis, and research.

As a highly experienced Data Analyst, I specialize in providing comprehensive solutions that support data-driven decision-making. With more than 5 years of experience working for international corporations across various industries, I have the expertise and skillset to deliver high-quality results that meet the highest standards. I am seeking long-term business partnerships with small to medium-sized companies on Upwork, but am open to working with larger companies as well. My data-related services can help transform your business by developing and implementing a comprehensive Business Intelligence system that covers all of your needs, from data warehousing to automated report creation. ❕Here are some of my areas of expertise:❕ ✅ Business Intelligence Integration: - I can create and automate reporting tools - Develop analytical dashboards - Process data through ETL pipelines and assure data quality ✅ Data modeling: - Perform statistical analysis - Build and develop predictive, classification, and scoring models - Conduct probabilistic sensitivity analysis (Monte Carlo simulations) - Develop NLP models for Natural Language Processing - Perform financial analysis and forecasting ❕Here is my tech stack:❕ ✅ Excel - Expert level: - I have expertise in all possible Excel formulas - I'm proficient in VBA - I can work with Power Queries, Power Pivots, and DAX formulas. ✅ SQL for Data Analysis and Data Engineering: - I can transform data using complex SQL solutions - Create ETL pipelines with SSIS ✅ Python for Data Analysis: - I can work with Pandas, Numpy, Seaborn, Matplotlib, and other Python libraries - I can create simple GUIs - Use Python for ETL processes ✅ PowerBI: - I can build your dashboards - Work with Power Queries and DB connections - Use DAX for advanced dashboard features ✅ Looker: - I provide data visualization services - Work with DB connections Thank you for considering my profile. I look forward to discussing how I can help you achieve your data-driven goals.

As a Senior Data Architect, I have 5+ years of experience in developing ETL pipelines, large-scale data engineering infrastructures, data mining, and warehousing projects. Further, I have managed and successfully deployed multiple data analytics projects, followed by expert MLOps services for maintaining the integrity and performance of various models in production. ✔️ ETL and Warehousing Services • I have developed and deployed complex data mining architectures involving hundreds of websites and millions of records, coupled with scraping solutions addressing JS, login/authentication, CAPTCHA, ReCAPTCHA, IP blacklisting, User-Agent Rotation, etc. • I'm highly skilled in Python, Scrapy, Beautiful Soup, Selenium, Splash, Regular expressions, XPath, JS, and AJAX. ✔️ Data Engineering Services • I have developed robust data pipelines, capable of continuous and extensible data processing. • I have implemented end-to-end solutions catering to diverse data sources, deployed on cloud/servers via cron jobs/automated services. ✔️ Data Science and Analytics Services • I offer expert data analysis for extracting key insights and complex correlations. Further, I can help identify key metrics for performance optimization across various niche. • I provide real-time BI services based on crafty yet simplistic visualizations across various platforms such as Google Data Studio, PowerBI, Tableau. • I have deployed multiple data science solutions in production based on complex statistical models and ingenious feature engineering, which provide insightful forecasting and predictive analytics. • I offer expert MLOps services for developing and optimizing in-production ML pipelines, impervious to data drift/leakage. I build optimal solutions for my valued clients across a diverse array of SMEs, following the best Software Engineering practices based on smart Requirement Analysis and industrious Quality Assurance. Keywords: Python, Google Data Studio, Google Analytics, Google Tag Manager, Tableau, MLflow, TensorFlow, R, Data Pipelines, ETL, Data Engineering, Data Extraction, Data Mining & Warehousing, Scrapy, Selenium, BeautifulSoup, Automation, Scrapers, NumPy, Pandas, NLP, Data Analytics, Forecasting.

I am a Zoho Authorized Partner who has been building and deploying CRM systems for small and large corporations. I have worked in a variety of industries such as financial, technology, marketing, and retail. Zoho provides what I believe to be a unique platform that enables a business to succeed without the need for complicated and costly software development. This is the key reason why I have chosen Zoho CRM and the entire Zoho platform for my specialty. Most recently, I have completed large and small Zoho implementations for 20 different companies from all different industries (e.g. online newspaper, coworking workspace company, fitness facility, credit repair company, small business loan network facilitator). I am an expert in integrating and building customized client solutions. I also have extensive experience in sales management, data analytics, and fine-tuning operational processes. I pride myself on finding the most cost-effective solutions to any opportunity that I encounter.

Business consultant, analyst, and software engineer for: -statistical/machine learning models (natural language processing, networks, linear regression, classification trees), -large and/or disparate data sets, performance metrics, forecasting -open source statistical programming (R and Python) -open source plotting software development (D3.js) -Many flavors of SQL and NoSQL database design and query writing for analytics and data science workflows -tabular data, spatial/GIS analysis (geoJSON) and text analysis (CNN) Recent Contracts/projects: - a full stack data science as a service Shiny app for survey analysis - a full stack data science as a service Shiny app for a statewide juvenile probation program - a full stack marketing analytics as a service Shiny app for medical practitioners - a full stack epidemiological analytics as a service Shiny app for international flu data network - led a team of junior data scientists supporting product managers for a food ordering app - prediction model for digital content subscription service - prediction and clustering models for online ordering behavior - classifying millions of Common Crawler web pages using a random forest classifier - employer group health plan analytics reporting software and ad hoc analyses - several custom d3.js data visualization libraries extended with R

A dynamic Statistician and Data Analyst seeks to bring an accomplished combination of education and experience to an industry-leading employer. 5+ years of experience in related data analysis, computer programming, and instruction roles for distinguished universities. Ph.D. Candidate in Biostatistics, with an M.S. in both Bio-Engineering and Applied Mathematics. Proficient in data management, mathematical modeling, grad/undergrad instruction, longitudinal/statistical analysis, project management, and more. Diligent and goal-oriented, with the skills, education, and hands-on experience needed to make an immediate impact as part of any fast-paced team.

My favorite topics are business applications and data visualization. I have a good understanding of accounting and IT. Service I provided: - Power BI - Data visualization - Power Query and data transformation - Data modeling - Writing DAX measures - Power BI training and ongoing support - Excel , GoogleSheet and google script support. - QuickBooks data migration - Consildated financial reports for QuickBooks online using Googlesheet & LiveFlow - QuickBooks training and ongoing support - QuickBooks integration with third party - Business applications support (Salesforce,Zapier, Stripe, SQUAREUP, unleashed ,Handifox - inventory,Etsy,POS,various payment gateway) - Cleaning books and prepare it for taxation - Excel , GoogleSheet and google script support Certification: - Microsoft Data analyst , 2020 - QuickBooks proadvisor certification in online , 2017 - QuickBooks proadvisor certification in Desktop , 2008 I look forward to learning about your project, and I appreciate this opportunity

Data Analyst and Microsoft Excel expert specializing in sourcing large amounts of data to organize and analyze, data visualization, data auditing, and a wide range of other analytical skills. I hold a Master's Degree in Consumer Analytics and have experience professionally working for a Fortune 500 company as a Business Analyst. Projects I could help you with: - Excel file troubleshooting. Ex. formula fixes, solving errors, etc. - Creating meaningful and professional-looking dashboards in both Microsoft Excel and Microsoft Power BI - Combining large datasets (thousands and/or millions or rows) and cleaning them up for analysis, tables, or graphs - Data visualization. Ex. Graphs and tables within Microsoft Excel, Graphics within Microsoft Power BI, Data visuals for PowerPoint presentations Please send me a message if you would like to work together!

Hello! I provide solutions. Industrial Engineer (University of Buenos Aires) who enjoys learning something new every day and applying my skills to solve problems. 5+ years experience in data analysis, data science, machine learning models (Python, R) and data visualization. I am a nerd who loves numbers and mathematical models, and find joy in transforming complex business problems into mathematical problems and questions that can be solved analytically. I find interest in every challenge as long as I am sure that I can complete it successfully. I view each job as a learning experience and try to keep in contact with my clients for future projects. My skills include: - Data Analysis & Visualization (Excel, Python, R) - Data Science (Python, R) - Dashboards (Power BI, Google Data Studio) - Predictive Modeling (Machine Learning, Neural Networks) - Statistical Analysis - Web Scraping (Python, R) - Map Visualizations (QGIS, R) - Probability Modelling & Estimation - Academic Writing, Proofreading & Commenting - Financial Planning - Market Research & Benchmarking - Operations Research & Management I also consider myself a fast learner and I speak my mind if I believe there is something that can be improved, as long as the time and place is right. I ALWAYS respect deadlines, and never take a job if I can't deliver it on time and form. Proficient in English & Spanish. Interests: Running, chess, singing, playing guitar, and football (soccer). Feel free to contact me if you want me to assist you, I'll be more than happy to do so.

Experienced Data Analyst adept at turning large data sets into easily digestible dashboards and visualizations - Skilled in Tableau, Power BI, Google Data Studio, and SQL Studio - Statistical analysis and Data Mining in R - Extensive work manipulating data in Excel - Most experienced with Marketing and advertising data, specifically ecommerce - Great team member, strong communication and collaboration skills

With 17 years experience building, developing, executing, and delivering online marketing strategies with large brands like: -Disney (SEO and A/B Testing specialist) -Universal (Senior Analytics and GTM and Optimization Specialist) -Nissan (Senior Analytics and GTM and Optimization Specialist) -KPMG (Senior Analytics and GTM and Optimization Specialist) -Pepsi (Senior Analytics and GTM and Optimization Specialist) -Gatorade (Web Developer) -participaction.com (Senior Analytics and GTM implementation specialist) -Centre for Addiction and Mental Health (Senior Analytics and GTM implementation specialist) Also work with over a hundred SMB’s through theDigiblender (my company), including SEO and SEM, Social Media Marketing, Email Marketing and Content Marketing solution based on data driven decision making. This include: -Website development -Planning and budgeting for long-term Search Engine Optimization -Email Marketing Campaigns -Both online and off-line web-based marketing -A/B Testing --Implementing pixels via DTM and GTM Creating weekly and monthly reports on campaign progress All Analytics (certified with both Google Analytics and Adobe Site catalyst) All A/B testing (Adobe Target and Google Experiments) All Audience Segmentation (Audience Manager and Google Remarketing Lists) All Analytics, Tags, Pixels, Data Layers implementation (Google tag Manger and Adobe Tag Manger) Analytics: Advanced Segmentation including creating base, ecommerce and custom Google Analytics code Create and organize Accounts, Custom Dimensions, Custom Metrics, Properties, Reporting views, Reporting-view filters, User management, Custom Reports and Widgets including customized team reports Event and Campaign Tracking Fault reporting with segmentation Conversion rate analysis Create audiences, attribution models for Dynamic Remarketing campaign in Google Ads. Conversion Tracking & Optimization Multi-Channel Funnels Reporting by querying the traffic source paths that lead to a user’s goal conversion. Adwords Campaign Optimization Setting up site search Using content grouping Track user interactions in AMP pages I am certified with Google Analytics and AdWords. I strongly believe that AdWords without the Analytics is like fridge without a door, it may keep things cold but you are throwing away money. Understand user behavior and intent with Event Tracking Analyze data by channel, audience via Custom Reports Enable Remarketing and Advertising Reporting Features in Analytics Measuring the performance of search engines over time through segmentation SEO Over ten years knowledge of SEO, including implement an SEO plan for many successful campaigns – for both desktop and Mobile, this included Facebook and Google advertising landing page optimization, and optimization for local search (mobile). A web development background and site architecture knowledge gives me a unique understanding of SEO and SEM, including sitemap creation and tracking metrics, title page optimization, keyword optimization including: referrals, link popularity, rankings, and saturation. Advise all stakeholders, web developers, designers and copywriters, in the production of all Campaigns conducive to producing high search engine rankings. Responsible for all aspects of SEM including SEO, PPCs that improve clients’ visibility with search engines as well as meet their Return on Investment goals. Daily research of search engine algorithms and provide analyses for clients and/or internal team members utilizing industry software to monitor clients’ search engine rankings, and perform keyword research using tools such as Keyword Explorer from Moz, Ahrefs, Raven, SpyFu, WordTracker, Keyword Max and Web Position Gold. Very Comfortable presenting to clients, serving as the day-to-day client contact, educating stakeholders about SEM strategies and efforts. I stay abreast of trends in SEM, PPC, SEO (post Panda & Penguin) and consistently seek new opportunities and ways to enhance/improve SEM results.

Professional, detail-oriented data administrator motivated to be a supportive force to any team. Automation is my passion, and through it, there is unlimited potential for increasing speed, efficiency, and accuracy for any team or scenario. - 10+ years of professional experience with Microsoft Office and Excel automation. - 7+ years of Social Media and SEO consultation and management. - 4+ years of Power BI Development. - 4+ years of CRM Administration. - 2+ years of Data Analysis and Visualization. - 2+ years of Tableau, Zoho Analytics, Klipfolio BI tool. - 2+ years of using SQL for data analysis - 1 year of Shopkeep POS, Quickbooks Online, and Bigcommerce implementation and management. - CRM Proficiencies: Salesforce, Hubspot, and Zoho.

Experienced Leader with an entrepreneurial spirit and a demonstrated history of driving improvements in the information technology and services industry. I am skilled in Business Process Management, Operations Management, Customer Satisfaction Program Management, Balanced Scorecard Development and Implementation, Transformational Change Management, Program & Project Management, Performance Management & Reporting including KPIs, OKRs, SLAs, & SLO's, and Communications & Presentation Skills. I lead the development and implementation of a strategy management system which included the development and rollout of Strategy Maps, Balanced Scorecards, Strategic Initiative Tracking tool (program & project management methodologies), KPIs and OKRs with related Dashboards, Scorecards, and performance reports. I provided assistance in establishing a robust meetings and reporting framework to support the ongoing management of the "Strategy Management System" and provided training and support to the client's personnel. I have over 15 years experience in application development in Excel using VBA to bring innovative solutions or automation to solve complex client problems, implement the solution and train the client to maintain the solutions after implementation. I am especially experienced in building high performance teams and strong, trusted client and stakeholder relationships.

Accomplished Data Engineer with multiple years of experience designing and implementing data solutions. AWS certifications in Solutions Architecture and Big Data

Data Analyst/ Developer specialized in data analysis, A/B test, data visualizations, automation, backend, looker studio , google analytics , python, sql, pyspark, node js, ETL, databricks, DBT, extracting actionable insights from data. Exploratory analysis , data analysis, business analytics, descriptive and inferential statistics, designing experiments.

I am a published quantitative social scientist and data scientist. I also have a MBA. Outside Upwork, I provide business and academic consulting services (wz-consulting.com). I have advanced statistical analytical skills that can be applied in commercial and academic projects. Additionally, for academic research, I have experience in publishing academic works. As a trained academic, I follow high standards of procedures for data management and analysis. I always seek to provide objective and reliable instead of easy solutions and answers. As a native Chinese/Mandarin and Shanghainese speaker, I also offer translation between English and Mandarin or Shanghainese, and tutoring service.

I have many years of experience creating Excel based tools and reports for a major aerospace company, and have excellent interpersonal skills. I can use these skills and experience to create automated spreadsheet tools and reports to help you be more successful in managing your work or life! I have used excel for many different types of tasks and presentations during my career, but most of my higher level excel capabilities were developed by creating monthly reports that highlighted key metrics for a major aerospace engineering organization. My capabilities have evolved over a 20 year timeframe to include more complexity, increased automation, and improved data visualizations to meet our business needs. More recently, I have brought these skills to the Upwork platform where I have now built a strong reputation as a freelance consultant in this area. Client Feedback: “Great working with Kevin, he really knows how to produce a report, using pivot tables and power query, to a high standard. Met my tight deadline and exceeded my expectations with the quality of the output. Would definitely recommend and would work with him again” "I had a great experience with Kevin...he was very organized, his work was done professionally and promptly. I chose him because he felt trustworthy and real...was not disappointed. Will definitely use him again." Excel capabilities include: - automated reports with polished graphs / charts - dashboards created using Power BI, Excel, or PowerPoint - excel-based project gantt chart / resource planning tools - pivot tables and charts - dynamic named ranges, data tables, and power query - scenario manager, what if analyses, and data models - VBA macros - vlookup, index/match and many other advanced functions - and more… Reach out to me if you want to create reports from scratch, are looking to automate current reporting processes, or just need a quick fix for a spreadsheet.

I am a Microsoft Certified Power BI Professional and an experienced Business Intelligence Developer. I have strong understanding of data from collection to cleaning to reporting. I can help you develop a self-serve BI dashboard for your users (management/clients etc) to navigate through the data by themselves, or it can be a dashboard that allows you to export visualizations into Powerpoint or analyzed data into Excel spreadsheet. I can help define the right dimensions and measures to analyze data and develop useful reports and insights that suits your needs. I have over 5 years of experience working as a Business Analyst and 10 years working as an IT Consultant for varioius multinational organizations including HP Canada. I also hold PMI's Project Management Professional certificate and experienced Lean Six Sigma professional with expertise in process mapping and process improvement. Education: MBA in Information Systems BSc in Computer Science Tools: Microsoft Power BI Power BI Dataflows Microsoft Excel Microsoft Project Microsoft Visio

Hi! I empower businesses by helping them solve business problems using qualitative and quantitative data and recommend actionable solutions that are the best fit. Depending on the problem, I have served as a data scientist and a business analyst for the past 7 years. Education from one of the top business schools in the world helps me build solutions that are practical and consumable. Details on Experience: • Analytics Strategy: Maturity assessment, problem roadmap, priority assessment, and solution design • Predictive analytics: Demand forecasting, next purchase/visit, event or success, LTV • Prescriptive analytics: Inventory optimization, assortment planning, catalog optimization, pricing, business driver analysis, customer funnel optimization- targeting, acquisition, engagement, customer segmentation • Descriptive analytics: Studying trends, drivers of the business, KPI assessment and identification, performance tracking and management, basic statistics, advance quantitative analysis • Visualization: Interactive and intuitive dashboards Tableau and Power BI • Data analytics skillset: arima, arimax, exponential smoothening, Classification techniques: Chaid, Cart, Random forest, decision trees, XG Boost, Regression techniques: Linear, Logistic, Lasso, Ridge, Stepwise My strengths are First-principles thinking, intuitiveness and keen understanding of business and time and again my clients have appreciated the actionability of my solutions Looking forward to hearing from you!

I am a seasoned Data Analyst, having worked with data analytics firms where I highly honed my skills. I have a background in Finance and Information Technology from Maseno University, where I studied International Finance, Public Finance, Money and Banking, Money Markets, Portfolio Analysis, and a host of other related disciplines. I am a Google Data Studio expert and highly proficient in statistical tools like MINITAB, SPSS, STATA, EVIEWS, R, and NVIVO, which I use to analyze data and tell stories. From the analyzed data, I write a report. Currently, I am pursuing my master's in Financial Analysis and Modelling.

✅TOP RATED Freelancer on Upwork with long term and consistent track record of gratifying and exceeding client expectations. I can assist you with the following: 1] MS Excel : (Literally anything related to Microsoft Excel, including VBA, reporting, automation, formulas, forms, reports, etc.) 2] Tableau : reporting & data visualization 3] PowerBI : reporting & data visualization 4] SQL Server: DBA and reporting 5] Tech content creation, coaching & instructing. e.g. online courses (I have created over a dozen online courses for Skillsoft), power point presentations, sentiment analysis, articles, reports, etc.   ✅I have worked with clients on every continent on the planet and I have assisted many individuals and all kinds of businesses from sole proprietors to startups to small, medium-sized and HUGE companies, many in the fortune 500 list. Some of my most recognized clients are the following: 1] Citi Bank 2] Microsoft 3] Orange Theory Fitness 4] Skillsoft 5] Walmart ✅Five Important things to keep in mind before reaching out to me: 1] I must have a quick 15-minute video call (free of charge) with each one of my clients before accepting a contract. It is customary that we have a brief preliminary meeting before I begin working with you 2] I do not accept rushed projects. If you want something done within the next few hours (or depending on the scope of your project even the next few days) I won't be able to help you. Moreover, I respond to all messages and new job invitations within 24 hours 3] I typically require a week or more to complete a particular milestone (Exceptions may apply!). Timelines and due dates are to be discussed/negotiated during our video calls 4] I only communicate through Upwork. Please do NOT send me your email, phone number, etc. All communications must be done through Upwork, and video calls will be conducted through the Upwork ZOOM feature 5] I only accept hourly contracts. The only exception is if your budget is greater than $5,000 and we get into a contract with multiple milestones. I do not complete quizes and/or skill evaluation projects prior to being retained. All the time I devote to your project after our first free video call is billable

I have more than 5 years of experience working a generalist data analysis role covering all stages of data processing from collection/scraping and ETL to visualization (Power BI/Tableau) and storage (postgres, MS SQL Server, MS Access, MS Excel, Google Sheets). Expert user of MS Excel, MS Access and Google Sheets, working knowledge of developing macros and scripts. Good command of SQL (primarily Vertica SQL, postgres and Google API Query Language) and data warehousing principles. Expert user of Microsoft Power BI and Tableau, some previous experience with Qlikview and Qliksense.